
*** Load Data
import delimited using .../04_cordcutters.dta, clear
append using .../04_other_subs.dta

*** Fix Date Variables
rename date date2
gen date = date(date2,"YMD")
gen week = week(date)

*** Save Household-level Dataset
collapse (mean) tot_* level_* monthly_amt (first) d_* mode_* is_cordcutter* date_cut, by(customer_key) fast
	
export delimited using /.../cord_cutter_sample_hhlev.csv, replace
save .../cord_cutter_sample_hhlev.dta, replace
